﻿create database Blog_EFRepository
go

create table Customer(
	Id int identity primary key,
	[Name] nvarchar(30) not null,
	Active bit not null, 
)

create table [Order](
	Id int identity primary key,
	[Date] datetime not null,
	CustomerId int not null foreign key references Customer(Id)
)

create table [OrderDetails](
	Id int identity primary key,
	Item nvarchar(30) not null,
	Amount decimal not null,
	OrderId int not null foreign key references [Order](Id)
)	

